package com.ctshk.rpc.order.tour.mapper;

import com.ctshk.rpc.order.tour.req.SeriesOrderReceiptTouristListReq;
import org.apache.ibatis.annotations.Param;

/**
 * <p>
 * 系列团收据关联游客 Provider 接口
 * </p>
 *
 * @author 谭响
 * @since 2021-01-18
 */
public class SeriesOrderReceiptTouristProvider {

    public String selectListBySelective(@Param("req") SeriesOrderReceiptTouristListReq req) {
        StringBuilder sb = new StringBuilder();
        sb.append("select ");
        sb.append("tsoti.cn_surname, tsoti.cn_name ");
        sb.append("FROM t_series_order_receipt_tourist tsort ");
        sb.append("left join t_series_order_tourist_info tsoti on tsort.tourist_id = tsoti.id ");
        sb.append("where 1=1 ");
        sb.append("and tsort.receipt_id = #{req.receiptId}");
        return sb.toString();
    }


}
